UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Digz/RdGwJrSCAnDoULBQFLaVYjBT4KuSXo/snrk/OI='
WHERE
key_id = 'ed9cc0f04f37512b10f30fb5c884c039fa6aa56b1f9b13f30d48bbc710dfc692'
AND (
token = 'Digz/RdGwJrSCAnDoULBQFLaVYjBT4KuSXo/snrk/OI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)