UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '50gMeYXBycdX6Y8mjSxgiFRb52PzlVyq85f7oju6jt8='
WHERE
key_id = '212da8ba98294da94a522ac4be8725ffa1303df1f7bab49707233077c8c89730'
AND (
token = '50gMeYXBycdX6Y8mjSxgiFRb52PzlVyq85f7oju6jt8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)