UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DfIg9KKkuNBlY8Aq7K2Kb1OQuMrpw3RgnrDkz/XK4c4='
WHERE
key_id = '8ef793c1c631951fb30136b1288caaad36206d6a3d03e9bcc6f036c258c2fffc'
AND (
token = 'DfIg9KKkuNBlY8Aq7K2Kb1OQuMrpw3RgnrDkz/XK4c4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)