UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oXgmsItprwIuzpwHhCour9IaJH58rqLQ0Y4z3vgwIAA='
WHERE
key_id = '24f977c7c580487cfd6ff90bcdf60874f769f114303687f1a520f2d57b2252ae'
AND (
token = 'oXgmsItprwIuzpwHhCour9IaJH58rqLQ0Y4z3vgwIAA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)