UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Dzg5S9wTYl80sjb1KwkF5Vb+0Wbwq/JT8OGMV6oLFfU='
WHERE
key_id = '4419617b7a95868723c96d811cb1168c77b0ffccce513407c6e60318119fedc9'
AND (
token = 'Dzg5S9wTYl80sjb1KwkF5Vb+0Wbwq/JT8OGMV6oLFfU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)