UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VzSPpF/Fk+p/TwuJCH+T0s1jJFZWXwZMwaMeuygRGkQ='
WHERE
key_id = '1789531dce44fd71139393ad12ffeaf3c8dec32706b46949858438a92bc3a45e'
AND (
token = 'VzSPpF/Fk+p/TwuJCH+T0s1jJFZWXwZMwaMeuygRGkQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)