UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZlIn+nVPfHYyfam71YuXzblf09dDn87Wj8abp3n8WY0='
WHERE
key_id = '7dfd0d0fdc8e8168c4264dffd1aa91254e406f5c12bebe51319dce1959b2e4bc'
AND (
token = 'ZlIn+nVPfHYyfam71YuXzblf09dDn87Wj8abp3n8WY0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)