UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MZsxlum0o2P1W9ldcgNiBzLVPTJLzC8an58myaL+r90='
WHERE
key_id = 'b9dfa36d0c007ed57b82d1a7275b5c7935e16b92c8acb578c68f3bea0dc84900'
AND (
token = 'MZsxlum0o2P1W9ldcgNiBzLVPTJLzC8an58myaL+r90='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)