UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hPwohbiJEret9E+x6f1XgXIEE/aeHYOUQtPZxJES9as='
WHERE
key_id = 'a632fd6c7c9145e91ee8165ce2d5c727b4f43e8363f053906db6886683bff6f0'
AND (
token = 'hPwohbiJEret9E+x6f1XgXIEE/aeHYOUQtPZxJES9as='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)