UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5gkg1f5GXiQIRzIRbyb81i0zJ6C7H14qocEwVlcxXno='
WHERE
key_id = 'bfe0c058e33c1a11a69cd9634a8f4958862ac67859bee078cb5b96de8447f597'
AND (
token = '5gkg1f5GXiQIRzIRbyb81i0zJ6C7H14qocEwVlcxXno='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)