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