UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'miOd87juTuSpFrhJUsaC45hyG9N2ukbCJftDAyvbhtE='
WHERE
key_id = 'ebae7ac9e3b99a20386e02362cb43be74392da1f5942ef0b78efd2df1860c06e'
AND (
token = 'miOd87juTuSpFrhJUsaC45hyG9N2ukbCJftDAyvbhtE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)