UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lk6MDRpKrDb2kKsq0m5aHdufi0tiHt0j6D6iXwKRFEU='
WHERE
key_id = '3c1c1a7dffc2f92d3798f00a9d6bb84089624ebb70c8a3f5c4f1b7d666724392'
AND (
token = 'lk6MDRpKrDb2kKsq0m5aHdufi0tiHt0j6D6iXwKRFEU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)