UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cjnYWezRzuE/OEOrVYLVKm4Il4EFlweVFIKM54mGgfE='
WHERE
key_id = '248d316f3ad0c7bbd6537074d4dcf22818dabcff627ad519fd45077f9c863fad'
AND (
token = 'cjnYWezRzuE/OEOrVYLVKm4Il4EFlweVFIKM54mGgfE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)