UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zVXLkVlt1+pqTsT0oQElol1l0AIEkVtFyOF0SFl8fSo='
WHERE
key_id = 'f37a103dba2c4c4a239b74d736b0a84b1b8ab58a47c8e0f1c0f1c26d8c396659'
AND (
token = 'zVXLkVlt1+pqTsT0oQElol1l0AIEkVtFyOF0SFl8fSo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)