UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7dLcTg08H/EUQ9DHWjAP2ad8AJSvaHuS08YeSIk0UKQ='
WHERE
key_id = '394d64534cfc310868e36003ea70288d1f1553802b18d75f5cf14e9e7f802d1a'
AND (
token = '7dLcTg08H/EUQ9DHWjAP2ad8AJSvaHuS08YeSIk0UKQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)