UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tUE60iiBl7tAryscAolTIVWzmvq1miXmtiN8e/f3eBM='
WHERE
key_id = 'f5629c3c8699a7bac2e5acb3e90f5daf78f8de805e5f114737997cc8f10a4af3'
AND (
token = 'tUE60iiBl7tAryscAolTIVWzmvq1miXmtiN8e/f3eBM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)