UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NnjSxnvvj6I7KFRUiZ0KYKE4N9TsTU968t332PrrxzE='
WHERE
key_id = 'd78e2c8e4f66f9c567a5958dd35a51f7b6e32370275f6d6415b387183159e4ba'
AND (
token = 'NnjSxnvvj6I7KFRUiZ0KYKE4N9TsTU968t332PrrxzE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)