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