UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'k1bC7Nc4C7lu0wxgAM8JGFsQ8s6az6VNgNv1YR8QshA='
WHERE
key_id = '271a519ace9e411ab543271447fe649a350a365f8280776528eecf86590cd6f3'
AND (
token = 'k1bC7Nc4C7lu0wxgAM8JGFsQ8s6az6VNgNv1YR8QshA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)