UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QDZBna2pOzDTfMaCakpLyFS9JH45dy+kGVGey0rxfl4='
WHERE
key_id = 'f8e6689b9283ce145c2adbee908dc8d6a81be70cfcc1107c6761537d9b8f568a'
AND (
token = 'QDZBna2pOzDTfMaCakpLyFS9JH45dy+kGVGey0rxfl4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)