UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'L3L+iWt08XjqdSwwLzUfJeWDafHXaMuQJntFj9m1qjo='
WHERE
key_id = '71ae2bdca93335064af7ee704b706b89093931035f890f9596a6dc8e157e1bd5'
AND (
token = 'L3L+iWt08XjqdSwwLzUfJeWDafHXaMuQJntFj9m1qjo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)