UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+zFULSjnd+EPc1FqUYZGKVEDqWGtt4WhpYOIhxMAREk='
WHERE
key_id = '149350a5b20d8a932c0b1bf5a6e35a791b4260cf07bd68af5b4773d86314b617'
AND (
token = '+zFULSjnd+EPc1FqUYZGKVEDqWGtt4WhpYOIhxMAREk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)