UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8QqBEnGnBbRC27k26JpgW/4XM6dTLYbdI82duoQD0Hc='
WHERE
key_id = 'f8a378f1fb4458ea6dbe1f7a1bc762308ea0ab13d5ef31752fb6a79915e0c41c'
AND (
token = '8QqBEnGnBbRC27k26JpgW/4XM6dTLYbdI82duoQD0Hc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)