UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '04vER0lYrLfSbARK+3z1GRJAsk9hzWsnNtRffDm9lOg='
WHERE
key_id = '6e507929036f0645057db880a787176afd934ec8f0e8be8eeea2b645ce1054e6'
AND (
token = '04vER0lYrLfSbARK+3z1GRJAsk9hzWsnNtRffDm9lOg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)