UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZyOqDlDHhBqAs2iSa3Sxl+mtUjstHE01WFja6yWAsGU='
WHERE
key_id = '7c80218fe44d0b703dc1652c54c7f3c58a5d89d84955ec6671b658d1144d1eb1'
AND (
token = 'ZyOqDlDHhBqAs2iSa3Sxl+mtUjstHE01WFja6yWAsGU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)