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