UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hRJerwn9c9oy6iAPK9eUKURsNniPlJ9bq92F0Iujqx0='
WHERE
key_id = '30cf96480f1160febc58c6b2a3cc37a24f5d8fd8b44825c69d49319efa724ad8'
AND (
token = 'hRJerwn9c9oy6iAPK9eUKURsNniPlJ9bq92F0Iujqx0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)