UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'u4hVGutIiG0Uibjl035XGqUYpharw4UtMn6plWeS7cc='
WHERE
key_id = '04f6a470ce6d1cdd2c36b7bf0233d2b36bdc64956d9bb6d299f46ad0f7c0f4b1'
AND (
token = 'u4hVGutIiG0Uibjl035XGqUYpharw4UtMn6plWeS7cc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)