UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TnIAZyVj2FvihO8i5P/DweVDrLmQgtapB+qfsHnhLC0='
WHERE
key_id = 'a943ce8e9e3f1bf07458e84cc0d623855723d5e39d0f5a4787143f2e7f7d9965'
AND (
token = 'TnIAZyVj2FvihO8i5P/DweVDrLmQgtapB+qfsHnhLC0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)